Release 10.1A: OpenEdge Data Management:
SQL Reference

DROP TABLE

Deletes the specified table.

Syntax

DROP TABLE [ owner_name.]table_name ;

owner_name

Specifies the owner of the table.

table_name

Names the table to drop.

Example

DROP TABLE customer ;

Notes

If owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.
When a table is dropped, the indexes on the table and the privileges associated with the table are dropped automatically.
Views dependent on the dropped table are not automatically dropped, but become invalid.
If the table is part of another table's referential constraint (if the table is named in another table’s REFERENCES clause), the DROP TABLE statement fails. You must DROP the referring table first.

Authorization

Must have DBA privilege or ownership of the table.

Related statements

CREATE TABLE